/*==============================================================*/
/* Table: TEmployee                                              */
/*==============================================================*/
create table TEmployee
(
Corp_ID          char(10)      NOT NULL,
Emp_ID           char(10)      NOT NULL,
Emp_Name         varchar(20)   NOT NULL,
Dep_Name         varchar(20)   ,
Title_Cd         varchar(20)   ,
ID_Number        char(18)      ,
Birth_Date	     smalldatetime ,
Gender           char(1)       NOT NULL,
Emp_Addr         varchar(90)   ,
Emp_PostCd       char(6)       ,
Emp_Tel          varchar(20)   ,
Emp_Mobile       varchar(20)   ,
Emp_Mail         varchar(40)   ,
Contract_Eff_Dt  smalldatetime ,
Contract_Exp_Dt  smalldatetime ,
Entry_Date       smalldatetime ,
Leave_Date       smalldatetime ,
Emp_Type         char(2)       NOT NULL,
Emp_Status       char(2)       NOT NULL,
Bank_Cd          varchar(10)   ,
Bank_AccountNo   varchar(40)   ,
Creator_User_ID  varchar(20)   NOT NULL,
TimeStamp        datetime      NOT NULL
CONSTRAINT [PK_TEmployee] PRIMARY KEY CLUSTERED
(Corp_ID ASC,Emp_ID ASC)
);
GO